﻿using ESCDB.DB;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.Mvc;

namespace WQPda.Controllers
{
    public class HomeController : Controller
    {
        public class Order
        {
            public string ORG_CODE { get; set; }
            public string TRANSACTION_SOURCE_NAME { get; set; }
        }
        public ActionResult Index()
        {
            WQEntities context = new WQEntities();
            var sqlResult = context.Database.SqlQuery<Order>("select r.*,rowid from rl_pda_wip_to_inv r");
            foreach (var order in sqlResult)
            {

            }

            return View();
        }

        public ActionResult About()
        {
            ViewBag.Message = "Your application description page.";

            return View();
        }

        public ActionResult Contact()
        {
            ViewBag.Message = "Your contact page.";

            return View();
        }
    }
}